www.gusucode.com > Piwik 网站流量统计系统 v2.9.1PHP源码程序 > Piwik 网站流量统计系统 v2.9.1/piwik/piwik/core/Updates/2.0-a12.php
<?php /** * Piwik - free/libre analytics platform * * @link http://piwik.org * @license http://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later * */ namespace Piwik\Updates; use Piwik\Common; use Piwik\Db; use Piwik\Updater; use Piwik\Updates; /** */ class Updates_2_0_a12 extends Updates { public static function getSql() { $result = array( 'ALTER TABLE ' . Common::prefixTable('logger_message') . ' MODIFY level VARCHAR(16) NULL' => false ); $unneededLogTables = array('logger_exception', 'logger_error', 'logger_api_call'); foreach ($unneededLogTables as $table) { $tableName = Common::prefixTable($table); try { $rows = Db::fetchOne("SELECT COUNT(*) FROM $tableName"); if ($rows == 0) { $result["DROP TABLE $tableName"] = false; } } catch (\Exception $ex) { // ignore } } return $result; } public static function update() { // change level column in logger_message table to string & remove other logging tables if empty Updater::updateDatabase(__FILE__, self::getSql()); } }